Steps to create Avg. First Response Time (Hours) Chart 11
i. Drag and drop First Rsp Hrs on the row field.
ii. Right click on SUM (First Rsp Hrs)
iii. Then right click on Measure (SUM)
iv. Then click Average
v. Drag and drop Created on the column shelves.
vi. Right click on Year(created).
vii. Click on Month.
viii. Drag and drop Created dimension on color card.
ix. Drag and drop Created dimension on Filter shelve.
x. Select Years.
xi. Click Next.
xii. Select ALL
xiii. Click OK.
xiv. Drag and drop First Rsp Hrs On Label card.
xv. Right click on SUM (First Rsp HRS)
xvi. Then click Measure (SUM).
xvii. Click Average.
After creating Avg. First Response Time (Hours) :
i. Drag and drop First Rsp Hrs on the row field.
ii. Right click on SUM (First Rsp Hrs)
iii. Then right click on Measure (SUM)
iv. Then click Average
v. Drag and drop Created on the column shelves.
vi. Right click on Year(created).
vii. Click on Month.
viii. Drag and drop Created dimension on color card.
ix. Drag and drop Created dimension on Filter shelve.
x. Select Years.
xi. Click Next.
xii. Select ALL
xiii. Click OK.
xiv. Drag and drop First Rsp Hrs On Label card.
xv. Right click on SUM (First Rsp HRS)
xvi. Then click Measure (SUM).
xvii. Click Average.
After creating Avg. First Response Time (Hours) :